Dashboard 03 - ZipCode - Creating Maps Visualizations - Part 02 20


Format tab

To format the visual, beneath the Visualizations pane, select the Format pane.


Under Format ->  General: X Position = 272 , Y Position = 235 , Width = 653 , Height = 365


Under Format ->  Data Colors = click on the letters fx ->  Format by = Color Scale , Based on field = .AVG_ResidentialPrice_PerSqFt , Minimum = Custom = Lowest Value and color = #F5C4AF , check Diverging, Middle Value and color = #EB895F , Maximum Value and color = #73361C


Under Format ->  Category = OFF

Under Format ->  Bubbles ->  Size = 45

Under Format ->  Map Controls ->  Auto Zoom = ON , Zoom buttons = ON

Under Format ->  Title ->  Set it to OFF

Under Format ->  Background ->  Set it to ON , Color = #FFFFFF

Under Format ->  Border ->  Set it to OFF



Step 2 - Configure Filter(s)

Filters

None.





Step 3:  Create a Map visual for Average Apartment Price per Sq. Ft.




In Power BI Desktop, click on the page, ZipCode

If selected, de-select a visualization by clicking an empty area of the report page.


Visualizations

To create the following visual, copy and paste the  Average House Price per Sq. Ft. visual that was created in Step 1 and use it as a template.


To create a copy of the visual, click the  Average House Price per Sq. Ft. visual , press Ctrl+C to copy, and then press Ctrl+V to paste




Fields

Select the following:

Under Visualizations, drag & drop it in the Location section:
Table_AptPricePerUnit_PerPricePerSqFt ->  Physical_Zip_Code


Under Visualizations, drag & drop it in the Size section:
A_KeyMeasures -> .AVG_AptUnitPrice_PerSqFt%


Under Visualizations, drag & drop it in the Tooltips section:
Township ->  .Township_Name
Township ->  .Township_Misc_Name




Visualizations


Fields tab

Under Fields tab, click on the down arrow ->  Rename for this visual and rename the fields as follows:

Physical_Zip_Code = Zip Code
.AVG_AptUnitPrice_PerSqFt% = AVG Apt Price/Sq. Ft.
.Township_Name = Township Name
.Township_Misc_Name = Township Misc. Name







Format tab

To format the visual, beneath the Visualizations pane, select the Format pane.



Under Format ->  General: X Position = 272 , Y Position = 660 , Width = 653 , Height = 368


Under Format ->  Data Colors = click on the letters fx ->  Format by = Color Scale , Based on field = .AVG_AptUnitPrice_PerSqFt , Minimum = Custom = Lowest Value and color = #A0A7D8 , check Diverging, Middle Value and color = #414FB1 , Maximum Value and color = #09124F


Under Format ->  Category = OFF

Under Format ->  Bubbles ->  Size = 45

Under Format ->  Map Controls ->  Auto Zoom = ON , Zoom buttons = ON

Under Format ->  Title ->  Set it to OFF

Under Format ->  Background ->  Set it to ON , Color = #FFFFFF

Under Format ->  Border ->  Set it to OFF



Step 4 - Configure Filter(s)

Filters

None.



When finished, save project.





How to create a Card visualization in Power BI